Metadata for object-relational data warehouse
نویسندگان
چکیده
For developing data warehouse (DW) and OnLine Analytical Processing (OLAP) systems, the dominant relational database reaches its limitations. On the way of the development, object-relational (O-R) database is preferred to get over those ones. This paper introduces metadata for data warehouse system on O-R database and specifies new kind of metadata for mapping from object-oriented environment to relational environment. We also present the storage structure for repository this new kind of metadata in O-R database.
منابع مشابه
Metadata Enrichment for Automatic Data Entry Based on Relational Data Models
The idea of automatic generation of data entry forms based on data relational models is a common and known idea that has been discussed day by day more than before according to the popularity of agile methods in software development accompanying development of programming tools. One of the requirements of the automation methods, whether in commercial products or the relevant research projects, ...
متن کاملUniversal Data Warehousing Based on a Meta-Data Modeling Approach
s – Data warehouse contains vast amount of data to support complex queries of various Decision Support Systems(DSSs). It needs to store materialized views of data, which must be available consistently and instantaneously. Using a frame metadata model, this paper presents an architecture of a universal data warehousing with different data models. The frame metadata model represents the metadata ...
متن کاملConcurrent Data Materialization for Object-Relational Database with Semantic Metadata
For a company with many databases in different data models, it is necessary to consolidate them into one data model interchangeable and present data in one data model concurrently to users. The benefit is to let user stick to his/her own data model to access database in another data model. This paper presents a semantic metadata to preserve database constraints for data materialization to suppo...
متن کاملWarehousing, Metadata, and Object-Based Analysis
Warehouse technology amasses teradata as the basis for Decision Support Systems (DSS). Key to knowledge formation is the organization and representation of such data. Identification of data structures enables the selection of decision support models. Use of object-classes with warehouse metadata allows creation of analytic frameworks. We discuss the production application of object-based SAS a...
متن کاملAn ETL Metadata Model for Data Warehousing
Metadata is essential for understanding information stored in data warehouses. It helps increase levels of adoption and usage of data warehouse data by knowledge workers and decision makers. A metadata model is important to the implementation of a data warehouse; the lack of a metadata model can lead to quality concerns about the data warehouse. A highly successful data warehouse implementation...
متن کامل